/*
 Navicat Premium Data Transfer

 Source Server         : lang-cloud
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 114.55.95.232:3306
 Source Schema         : nest-auth

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 17/08/2022 21:18:42
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级部门',
  `sub_count` tinyint(4) DEFAULT '0' COMMENT '子部门数目',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `sort` int(11) DEFAULT '999' COMMENT '排序',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除，（0.否，1.是）',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `inx_pid` (`pid`) USING BTREE,
  KEY `inx_enabled` (`is_delete`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (595225483309056, 0, 0, '成都指掌天下', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:36:39', NULL);
INSERT INTO `sys_dept` VALUES (595373827452928, 595225483309056, 0, 'JAVA研发中心', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:37:14', NULL);
INSERT INTO `sys_dept` VALUES (595435701825536, 595225483309056, 0, '.NET研发中心', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:37:29', NULL);
INSERT INTO `sys_dept` VALUES (595462448902144, 595225483309056, 0, '产品中心', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:37:35', NULL);
INSERT INTO `sys_dept` VALUES (595499736264704, 595225483309056, 0, '测试中心', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:37:44', NULL);
INSERT INTO `sys_dept` VALUES (595549321326592, 595225483309056, 0, '客户端中心', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:37:56', NULL);
INSERT INTO `sys_dept` VALUES (595658314510336, 595225483309056, 0, '平台中心', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:38:22', NULL);
INSERT INTO `sys_dept` VALUES (595704787398656, 595658314510336, 0, '财务部', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:38:33', NULL);
INSERT INTO `sys_dept` VALUES (595727549886464, 595658314510336, 0, '行政部', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:38:38', NULL);
INSERT INTO `sys_dept` VALUES (595811377246208, 595658314510336, 0, '人力行政部', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:38:58', NULL);
INSERT INTO `sys_dept` VALUES (596025387413504, 595549321326592, 0, '订货项目部', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:39:49', NULL);
INSERT INTO `sys_dept` VALUES (596051022999552, 595549321326592, 0, 'ERP项目部', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:39:55', NULL);
INSERT INTO `sys_dept` VALUES (596069834452992, 595549321326592, 0, 'CRM项目部', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:40:00', NULL);
INSERT INTO `sys_dept` VALUES (596111773298688, 595549321326592, 0, '零售项目部', '描述内容', 1, 0, 'admin', NULL, '2022-07-29 17:40:10', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '字典名称',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) DEFAULT '0' COMMENT '删除状态：（0.未删除，1.已删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=912779262763009 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='数据字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES (1, 'user_status', '用户状态', NULL, NULL, '2019-10-27 20:31:36', NULL, 0);
INSERT INTO `sys_dict` VALUES (4, 'dept_status', '部门状态', NULL, NULL, '2019-10-27 20:31:36', NULL, 0);
INSERT INTO `sys_dict` VALUES (5, 'job_status', '岗位状态', NULL, NULL, '2019-10-27 20:31:36', NULL, 1);
INSERT INTO `sys_dict` VALUES (168480776704000, 'test', NULL, NULL, NULL, '2022-06-14 09:42:38', NULL, 1);
INSERT INTO `sys_dict` VALUES (169631658815488, 'test1', NULL, NULL, NULL, '2022-06-14 09:47:12', NULL, 1);
INSERT INTO `sys_dict` VALUES (170165924143104, 'user_online_status', '描述内容哦', NULL, NULL, '2022-06-14 09:49:19', NULL, 1);
INSERT INTO `sys_dict` VALUES (170969947054080, 'user_online_status1', '描述内容哦', NULL, NULL, '2022-06-14 09:52:31', NULL, 1);
INSERT INTO `sys_dict` VALUES (172588596514816, 'user_online_status3', '描述内容哦', NULL, NULL, '2022-06-14 09:58:57', NULL, 1);
INSERT INTO `sys_dict` VALUES (272282107113472, 'menu_type', '菜单类型', NULL, NULL, '2022-07-28 20:13:23', NULL, 0);
INSERT INTO `sys_dict` VALUES (360295054819328, 'order_status', '单据状态', NULL, NULL, '2022-06-17 16:38:28', NULL, 0);
INSERT INTO `sys_dict` VALUES (486683767996416, 'menu_terminal', '菜单终端', NULL, NULL, '2022-07-29 10:25:20', NULL, 0);
INSERT INTO `sys_dict` VALUES (487311302983680, 'yes_no', '是&否', NULL, NULL, '2022-07-29 10:27:50', NULL, 1);
INSERT INTO `sys_dict` VALUES (487582183718912, 'sys_yes_no', '系统-是否', NULL, NULL, '2022-07-29 10:28:54', NULL, 0);
INSERT INTO `sys_dict` VALUES (523231175331840, 'login_status', '登录状态', NULL, NULL, '2022-06-15 09:12:17', NULL, 0);
INSERT INTO `sys_dict` VALUES (523284212305920, 'login_status1', '登录状态1', NULL, NULL, '2022-06-15 09:12:29', NULL, 1);
INSERT INTO `sys_dict` VALUES (523303254446080, 'login_status2', '登录状态1', NULL, NULL, '2022-06-15 09:12:34', NULL, 1);
INSERT INTO `sys_dict` VALUES (525068716691456, 'login_status3', '登录状态1', NULL, NULL, '2022-06-15 09:19:35', NULL, 1);
INSERT INTO `sys_dict` VALUES (526992513912832, 'login_status333', '登录状态1', NULL, NULL, '2022-06-15 09:27:13', NULL, 1);
INSERT INTO `sys_dict` VALUES (594713448501248, '查询用户状态', '11', NULL, NULL, '2022-06-15 13:56:19', NULL, 1);
INSERT INTO `sys_dict` VALUES (594911822303232, 'user_query_status', '查询状态', NULL, NULL, '2022-06-15 13:57:07', NULL, 0);
INSERT INTO `sys_dict` VALUES (595386373648384, 'user_name_style', '用户名风格', NULL, NULL, '2022-06-15 13:59:00', NULL, 1);
INSERT INTO `sys_dict` VALUES (595765622616064, 'out_lne', '退出状态', NULL, NULL, '2022-06-15 14:00:30', NULL, 1);
INSERT INTO `sys_dict` VALUES (912779262763008, 'job_type', '职位类型', NULL, NULL, '2022-06-16 11:00:12', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_detail`;
CREATE TABLE `sys_dict_detail` (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `dict_id` bigint(20) DEFAULT NULL COMMENT '字典id',
  `label` varchar(255) NOT NULL COMMENT '字典标签',
  `enabled` tinyint(1) DEFAULT '1' COMMENT '启用状态（0.禁用，1.启用）',
  `value` varchar(255) NOT NULL COMMENT '字典值',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) DEFAULT '0' COMMENT '删除状态（0.未删除，1.已删除）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK5tpkputc6d9nboxojdbgnpmyb` (`dict_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='数据字典详情';

-- ----------------------------
-- Records of sys_dict_detail
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_detail` VALUES (1, 1, '激活', 1, 'true', 1, NULL, NULL, '2019-10-27 20:31:36', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (2, 1, '禁用', 1, 'false', 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (3, 4, '启用', 1, 'true', 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (4, 4, '停用', 1, 'false', 2, NULL, NULL, '2019-10-27 20:31:36', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (5, 5, '启用', 1, '1', 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (6, 5, '停用', 1, '0', 2, NULL, NULL, '2019-10-27 20:31:36', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (172729340579840, 172588596514816, '启用', 1, '1', 1, NULL, NULL, '2022-06-14 09:59:30', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (272349366972416, 272282107113472, '目录', 1, '0', 999, NULL, NULL, '2022-07-28 20:13:39', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (272430489006080, 272282107113472, '页面', 1, '1', 999, NULL, NULL, '2022-07-28 20:13:58', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (272463443652608, 272282107113472, '操作按钮', 1, '2', 999, NULL, NULL, '2022-07-28 20:14:06', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (272560738922496, 272282107113472, '操作', 1, '2', 999, NULL, NULL, '2022-07-28 20:14:29', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (360357885493248, 360295054819328, '草稿', 1, '0', 999, NULL, NULL, '2022-06-17 16:38:43', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (360449547812864, 360295054819328, '流程中', 1, '1', 999, NULL, NULL, '2022-06-17 16:39:05', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (360482330492928, 360295054819328, '已完成', 1, '3', 999, NULL, NULL, '2022-06-17 16:39:13', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (366410876604416, 912779262763008, '兼职', 1, '2', 999, NULL, NULL, '2022-06-17 17:02:46', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (366442480685056, 912779262763008, '钟点工', 1, '3', 999, NULL, NULL, '2022-06-17 17:02:54', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (486749857644544, 486683767996416, 'PC', 1, '0', 999, NULL, NULL, '2022-07-29 10:25:36', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (486777984647168, 486683767996416, 'H5', 1, '1', 999, NULL, NULL, '2022-07-29 10:25:43', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (487355330592768, 487311302983680, '是', 1, '1', 999, NULL, NULL, '2022-07-29 10:28:00', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (487375513583616, 487311302983680, '否', 1, '0', 999, NULL, NULL, '2022-07-29 10:28:05', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (487615574573056, 487582183718912, '是', 1, '1', 999, NULL, NULL, '2022-07-29 10:29:02', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (487640794923008, 487582183718912, '否', 1, '0', 999, NULL, NULL, '2022-07-29 10:29:08', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (566237798551552, 523231175331840, '在线', 1, '1', 1, NULL, NULL, '2022-06-15 12:03:10', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (566279749980160, 523231175331840, '离线', 1, '0', 2, NULL, NULL, '2022-06-15 12:03:20', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (595831376719872, 595765622616064, '已退出', 1, '1', 1, NULL, NULL, '2022-06-15 14:00:46', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (595878185152512, 595765622616064, '未退出', 1, '2', 2, NULL, NULL, '2022-06-15 14:00:57', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (846598265810944, 1, '起飞', 1, '1', 1, NULL, NULL, '2022-06-13 12:23:35', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (846742702821376, 1, '起飞1', 1, '1', 1, NULL, NULL, '2022-06-13 12:24:09', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (868366903738368, 4, '测试1', 1, '111', 999, NULL, NULL, '2022-06-13 13:50:05', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (868542758322176, 4, '测试2', 1, '333', 999, NULL, NULL, '2022-06-13 13:50:47', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (868633825050624, 4, '测试3', 1, '1', 999, NULL, NULL, '2022-06-13 13:51:08', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (869321154035712, 4, '测试12', 1, '11', 999, NULL, NULL, '2022-06-13 13:53:52', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (896107233476608, 5, '停职', 1, '3', 999, NULL, NULL, '2022-06-13 15:40:19', NULL, 0);
INSERT INTO `sys_dict_detail` VALUES (912842424786944, 912779262763008, '全职', 1, '1', 999, NULL, NULL, '2022-06-16 11:00:27', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (912877338173440, 912779262763008, '兼职', 1, '2', 999, NULL, NULL, '2022-06-16 11:00:35', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (912909604954112, 912779262763008, '实习', 1, '3', 999, NULL, NULL, '2022-06-16 11:00:43', NULL, 1);
INSERT INTO `sys_dict_detail` VALUES (913095152574464, 912779262763008, '临时工', 1, '4', 999, NULL, NULL, '2022-06-16 11:01:27', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名',
  `origin_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '原始名称',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件路径',
  `size` bigint(20) DEFAULT '0' COMMENT '文件大小，单位（KB）',
  `suffix` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件后缀',
  `sign_hash` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件签名hash（由创建时间+修改时间+文件大小）组合,并转为MD5',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改人',
  `create_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `is_delete` tinyint(1) DEFAULT '0' COMMENT '删除（0.未删除，1.已删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
INSERT INTO `sys_file` VALUES (93857628655616, '93857628655616.png', '测试', 'public/uploads/png/2022-06-30/93857628655616.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:07:57', NULL, 0);
INSERT INTO `sys_file` VALUES (94067353894912, '94067353894912.png', '测试', 'public/uploads/png/2022-06-30/94067353894912.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:08:47', NULL, 0);
INSERT INTO `sys_file` VALUES (94304242720768, '94304242720768.png', '测试', 'public/uploads/png/2022-06-30/94304242720768.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:09:44', NULL, 0);
INSERT INTO `sys_file` VALUES (94536967872512, '94536967872512.png', '测试', 'public/uploads/png/2022-06-30/94536967872512.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:10:39', NULL, 0);
INSERT INTO `sys_file` VALUES (94540453339136, '94540453339136.png', '测试', 'public/uploads/png/2022-06-30/94540453339136.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:10:40', NULL, 0);
INSERT INTO `sys_file` VALUES (94543167053824, '94543167053824.png', '测试', 'public/uploads/png/2022-06-30/94543167053824.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:10:41', NULL, 0);
INSERT INTO `sys_file` VALUES (94544777666560, '94544777666560.png', '测试', 'public/uploads/png/2022-06-30/94544777666560.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:10:41', NULL, 0);
INSERT INTO `sys_file` VALUES (94546270838784, '94546270838784.png', '测试', 'public/uploads/png/2022-06-30/94546270838784.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:10:42', NULL, 0);
INSERT INTO `sys_file` VALUES (94548401545216, '94548401545216.png', '测试', 'public/uploads/png/2022-06-30/94548401545216.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:10:42', NULL, 0);
INSERT INTO `sys_file` VALUES (94549785665536, '94549785665536.png', '测试', 'public/uploads/png/2022-06-30/94549785665536.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:10:42', NULL, 0);
INSERT INTO `sys_file` VALUES (95542184071168, '95542184071168.png', '测试', 'public/uploads/images/2022-06-30/95542184071168.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:14:39', NULL, 0);
INSERT INTO `sys_file` VALUES (95934002028544, '95934002028544.png', '测试', 'public/uploads/images/2022-06-30/95934002028544.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:16:12', NULL, 0);
INSERT INTO `sys_file` VALUES (95937680433152, '95937680433152.png', '测试', 'public/uploads/images/2022-06-30/95937680433152.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:16:13', NULL, 0);
INSERT INTO `sys_file` VALUES (95961109815296, '95961109815296.png', '测试', 'public/uploads/images/2022-06-30/95961109815296.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:16:19', NULL, 0);
INSERT INTO `sys_file` VALUES (95962410049536, '95962410049536.png', '测试', 'public/uploads/images/2022-06-30/95962410049536.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:16:19', NULL, 0);
INSERT INTO `sys_file` VALUES (95965664829440, '95965664829440.png', '测试', 'public/uploads/images/2022-06-30/95965664829440.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:16:20', NULL, 0);
INSERT INTO `sys_file` VALUES (95967137030144, '95967137030144.png', '测试', 'public/uploads/images/2022-06-30/95967137030144.png', NULL, 'png', '123456666', '张三', NULL, '2022-06-30 18:16:20', NULL, 0);
INSERT INTO `sys_file` VALUES (96874330050560, '96874330050560.png', '测试', 'public/uploads/images/2022-06-30/96874330050560.png', 0, 'png', '123456666', '张三', NULL, '2022-06-30 18:19:57', NULL, 0);
INSERT INTO `sys_file` VALUES (97040924491776, '97040924491776.png', '测试', 'public/uploads/images/2022-06-30/97040924491776.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 18:20:36', NULL, 0);
INSERT INTO `sys_file` VALUES (97782771040256, '97782771040256.png', '测试', 'public/uploads/images/2022-06-30/97782771040256.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 18:23:33', NULL, 0);
INSERT INTO `sys_file` VALUES (110983822786560, '110983822786560.png', '测试', 'public/uploads/images/2022-06-30/110983822786560.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:16:01', NULL, 0);
INSERT INTO `sys_file` VALUES (111008472711168, '111008472711168.png', '测试', 'public/uploads/images/2022-06-30/111008472711168.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:16:07', NULL, 0);
INSERT INTO `sys_file` VALUES (111012381802496, '111012381802496.png', '测试', 'public/uploads/images/2022-06-30/111012381802496.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:16:07', NULL, 0);
INSERT INTO `sys_file` VALUES (111162999320576, '111162999320576.png', '111162999320576.png', 'public/uploads/images/2022-06-30/111162999320576.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:16:43', NULL, 0);
INSERT INTO `sys_file` VALUES (111361646813184, '111361646813184.png', '111361646813184.png', 'public/uploads/images/2022-06-30/111361646813184.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:17:31', NULL, 0);
INSERT INTO `sys_file` VALUES (111667662667776, '111667662667776.png', 'Snipaste_2022-05-24_10-44-54.png', 'public/uploads/images/2022-06-30/111667662667776.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:18:44', NULL, 0);
INSERT INTO `sys_file` VALUES (112553180905472, '112553180905472.png', 'Snipaste_2022-05-24_10-44-54.png', 'public/uploads/images/2022-06-30/112553180905472.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:22:15', NULL, 0);
INSERT INTO `sys_file` VALUES (112556926418944, '112556926418944.png', 'Snipaste_2022-05-24_10-44-54.png', 'public/uploads/images/2022-06-30/112556926418944.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:22:16', NULL, 0);
INSERT INTO `sys_file` VALUES (115997933420544, '115997933420544.png', 'Snipaste_2022-05-24_10-44-54.png', 'public/uploads/images/2022-06-30/115997933420544.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:35:56', NULL, 0);
INSERT INTO `sys_file` VALUES (121815041208320, '121815041208320.png', 'Snipaste_2022-05-24_10-44-54.png', 'public/uploads/images/2022-06-30/121815041208320.png', 81166, 'png', '123456666', '张三', NULL, '2022-06-30 19:59:03', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '岗位名称',
  `enabled` tinyint(1) NOT NULL DEFAULT '1' COMMENT '岗位状态（0.禁用，1.启用）',
  `job_sort` int(11) DEFAULT NULL COMMENT '排序',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态：（0.未删除，1.已删除）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`) USING BTREE,
  KEY `inx_enabled` (`enabled`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='岗位';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES (476853482143744, '总经理', 1, 999, '', NULL, NULL, '2022-06-09 17:40:42', NULL, 0);
INSERT INTO `sys_job` VALUES (487457789882368, '副总经理', 1, 999, '', NULL, NULL, '2022-06-09 18:22:50', NULL, 0);
INSERT INTO `sys_job` VALUES (488142592188416, 'Web前端开发', 1, 1, '', NULL, NULL, '2022-06-09 18:25:34', NULL, 0);
INSERT INTO `sys_job` VALUES (488168512987136, 'Java开发', 1, 999, '', NULL, NULL, '2022-06-09 18:25:40', NULL, 0);
INSERT INTO `sys_job` VALUES (488412621479936, '测试人员', 1, 999, '', NULL, NULL, '2022-06-09 18:26:38', NULL, 1);
INSERT INTO `sys_job` VALUES (519334167793664, '人力总监', 1, 999, '', NULL, NULL, '2022-06-15 08:56:47', NULL, 0);
INSERT INTO `sys_job` VALUES (712936289517568, '测试工程师', 1, 999, '', NULL, NULL, '2022-06-10 09:18:49', NULL, 0);
INSERT INTO `sys_job` VALUES (720239029960704, '总裁1', 1, 1, '', NULL, NULL, '2022-06-10 09:47:50', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `description` varchar(255) DEFAULT NULL,
  `log_type` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `params` text,
  `request_ip` varchar(255) DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `exception_detail` text,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `log_create_time_index` (`create_time`) USING BTREE,
  KEY `inx_log_type` (`log_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3537 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `pid` bigint(20) DEFAULT '0' COMMENT '父级ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单名称',
  `type` tinyint(1) DEFAULT '0' COMMENT '菜单类型（0.目录，1.页面，2.按钮）',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单路径',
  `icon` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单图标',
  `auth_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限标识编码，如：USER_QUERY',
  `sort` bigint(20) DEFAULT '0' COMMENT '排序',
  `terminal` tinyint(1) DEFAULT NULL COMMENT '使用终端，（0.PC， 1.H5）',
  `is_out_link` tinyint(1) NOT NULL COMMENT '是否为外部连接，（0.否，1.是）',
  `is_visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否可见，（0. 否，1.是）',
  `remark` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `is_delete` tinyint(1) DEFAULT '0' COMMENT '删除（0.否，1.是）',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建人',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (172596189908992, 0, '首页', 0, '', '', '', 999, 0, 0, 1, '', 0, 'admin', NULL, '2022-08-08 14:31:50', NULL);
INSERT INTO `sys_menu` VALUES (172960159027200, 0, '系统管理', 0, '/system-manage', '', '', 999, 0, 0, 1, '', 0, 'admin', NULL, '2022-08-08 14:33:17', NULL);
INSERT INTO `sys_menu` VALUES (173034645671936, 172960159027200, '用户管理', 1, '/user', '', '', 999, 0, 0, 1, '', 0, 'admin', NULL, '2022-08-08 14:33:35', NULL);
INSERT INTO `sys_menu` VALUES (173120188502016, 172960159027200, '菜单管理', 0, '/menu', '', '', 999, 0, 0, 1, '', 0, 'admin', NULL, '2022-08-08 14:33:55', NULL);
INSERT INTO `sys_menu` VALUES (173180565508096, 172960159027200, '字典管理', 0, '/dict', '', '', 999, 0, 0, 1, '', 0, 'admin', NULL, '2022-08-08 14:34:10', NULL);
INSERT INTO `sys_menu` VALUES (210588521336832, 172960159027200, '职位管理', 1, '', '', '', 999, 0, 0, 1, '', 0, 'admin', NULL, '2022-08-08 17:02:48', NULL);
INSERT INTO `sys_menu` VALUES (210650286657536, 172960159027200, '测试页面', 0, '/test', '', '', 999, 0, 0, 1, '', 1, 'admin', NULL, '2022-08-08 17:03:03', NULL);
INSERT INTO `sys_menu` VALUES (210832315256832, 172960159027200, '测试页面1', 1, '/test', '', '', 999, 0, 0, 1, '', 0, 'admin', NULL, '2022-08-08 17:03:46', NULL);
INSERT INTO `sys_menu` VALUES (792174188605440, 183139502821376, '批量删除', 2, '', 'ceshi', 'MENU_BATCH_DELETE', 1000, 1, 0, 1, NULL, 0, 'admin', NULL, '2022-08-15 20:01:06', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_group`;
CREATE TABLE `sys_menu_group` (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `is_delete` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除，（0.否，1.是）',
  `create_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_menu_group
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_group` VALUES (173746821713920, 'LMH管理员', 0, 'admin', NULL, '2022-08-08 14:36:25', NULL, '');
INSERT INTO `sys_menu_group` VALUES (221267082821632, '管理员专用分组', 0, 'admin', NULL, '2022-07-28 16:50:40', NULL, '描述文字');
INSERT INTO `sys_menu_group` VALUES (221547325243392, '开发人员', 0, 'admin', NULL, '2022-07-28 16:51:47', NULL, '');
INSERT INTO `sys_menu_group` VALUES (221586424545280, '测试人员', 0, 'admin', NULL, '2022-07-28 16:51:56', NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_group_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_group_menus`;
CREATE TABLE `sys_menu_group_menus` (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单id',
  `menu_group_id` bigint(20) NOT NULL COMMENT '菜单分组id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_menu_group_menus
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_group_menus` VALUES (173747593465856, 172596189908992, 173746821713920);
INSERT INTO `sys_menu_group_menus` VALUES (173747597660160, 172960159027200, 173746821713920);
INSERT INTO `sys_menu_group_menus` VALUES (173747597660161, 173034645671936, 173746821713920);
INSERT INTO `sys_menu_group_menus` VALUES (173747597660162, 173120188502016, 173746821713920);
INSERT INTO `sys_menu_group_menus` VALUES (173747597660163, 173180565508096, 173746821713920);
INSERT INTO `sys_menu_group_menus` VALUES (173747597660164, 210832315256832, 173746821713920);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `level` int(11) DEFAULT NULL COMMENT '角色级别',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `data_scope` varchar(255) DEFAULT NULL COMMENT '数据权限',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`) USING BTREE,
  KEY `role_name_index` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '超级管理员', 1, '-', '全部', NULL, 'admin', '2018-11-23 11:04:37', '2020-08-06 16:10:24');
INSERT INTO `sys_role` VALUES (2, '普通用户', 2, '-', '本级', NULL, 'admin', '2018-11-23 13:09:06', '2020-09-05 10:45:12');
INSERT INTO `sys_role` VALUES (3, '测试角色名称', 2, '', '本级', 'Admin', NULL, '2022-05-11 13:38:51', NULL);
INSERT INTO `sys_role` VALUES (7, '测试角色3', 2, '', '本级', 'Admin', NULL, '2022-05-11 13:43:57', NULL);
INSERT INTO `sys_role` VALUES (8, '测试角色4', 2, '', '本级', 'Admin', NULL, '2022-05-11 13:44:12', NULL);
INSERT INTO `sys_role` VALUES (9, '测试角色1', 2, '', '本级', 'Admin', NULL, '2022-05-11 13:44:47', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门名称',
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(255) DEFAULT NULL COMMENT '昵称',
  `gender` bigint(1) unsigned zerofill DEFAULT '0' COMMENT '性别, (0. 未知，1.男， 2.女)',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `avatar_name` varchar(255) DEFAULT NULL COMMENT '头像地址',
  `avatar_path` varchar(255) DEFAULT NULL COMMENT '头像真实路径',
  `auth_group_id` bigint(20) DEFAULT NULL COMMENT '权限组id',
  `job_id` bigint(20) DEFAULT NULL COMMENT '职位id',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `is_admin` bit(1) DEFAULT b'0' COMMENT '是否为admin账号',
  `enabled` bigint(20) DEFAULT '1' COMMENT '状态：1启用、0禁用',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `pwd_reset_time` datetime DEFAULT NULL COMMENT '修改密码的时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `is_delete` tinyint(1) DEFAULT '0' COMMENT '是否删除，（0.否，1.是）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (624466194784256, 595499736264704, 'test12', '测试人员1', 1, '13655881212', '77771717@qq.com', '11111', '', NULL, NULL, '182828228282', b'0', 1, '张学友', NULL, NULL, '2022-08-01 13:46:29', NULL, 0);
INSERT INTO `sys_user` VALUES (624481394941952, 595499736264704, 'test123', '测试人员1', 1, '13655881212', '77771717@qq.com', '11111', '', NULL, NULL, '182828228282', b'0', 1, '张学友', NULL, NULL, '2022-08-01 13:46:32', NULL, 0);
INSERT INTO `sys_user` VALUES (624660944707584, 595549321326592, 'dev2', '中级前端开发', 1, '13655881212', '77771717@qq.com', '11111', '', NULL, NULL, '182828228282', b'0', 1, '张学友', NULL, NULL, '2022-08-01 13:47:15', NULL, 0);
INSERT INTO `sys_user` VALUES (624679647109120, 595549321326592, 'dev3', '中级前端开发', 1, '13655881212', '77771717@qq.com', '11111', '', NULL, NULL, '182828228282', b'0', 1, '张学友', NULL, NULL, '2022-08-01 13:47:20', NULL, 0);
INSERT INTO `sys_user` VALUES (624716636676096, 595549321326592, 'dev4', '中级前端开发1', 1, '13655881212', '77771717@qq.com', '11111', '', NULL, NULL, '182828228282', b'0', 1, '张学友', NULL, NULL, '2022-08-01 13:47:28', NULL, 0);
INSERT INTO `sys_user` VALUES (624774010560512, 595549321326592, 'dev-admin', '前端开发主管', 1, '13655881212', '77771717@qq.com', '11111', '', NULL, NULL, '182828228282', b'0', 1, '张学友', NULL, NULL, '2022-08-01 13:47:42', NULL, 0);
INSERT INTO `sys_user` VALUES (744244887367680, 595225483309056, 'admin', '超级管理员', 1, '13655881212', '77771717@qq.com', '11111', '', 173746821713920, NULL, '123456', b'1', 1, '张学友', NULL, NULL, '2022-06-10 11:23:13', NULL, 0);
INSERT INTO `sys_user` VALUES (744244887367681, 595373827452928, 'dev1', '开发人员1', 0, NULL, '533354111@qq.com', NULL, NULL, 221547325243392, NULL, '123456', b'0', 1, 'admin', NULL, NULL, '2022-07-28 09:41:59', NULL, 0);
INSERT INTO `sys_user` VALUES (744244887367682, 595462448902144, 'test1', '测试1', 0, NULL, NULL, NULL, NULL, 221586424545280, NULL, NULL, b'0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user` VALUES (927372923760640, 595549321326592, 'dev-admin11', '前端开发主管', 1, '13655881212', '77771717@qq.com', '11111', '', NULL, NULL, '182828228282', b'0', 1, '张学友', NULL, NULL, '2022-08-02 09:50:07', NULL, 0);
INSERT INTO `sys_user` VALUES (931434698772480, 595658314510336, 'cd_test11', '成都彭于晏', 1, '13566885522', '12345678@qq.com', '', '', NULL, 488142592188416, '123456', b'0', 1, '张学友', NULL, NULL, '2022-08-02 10:06:16', NULL, 0);
INSERT INTO `sys_user` VALUES (933564469874688, 595658314510336, 'cd_test112', '成都彭于晏', 1, '13566885522', '12345678@qq.com', '', '', NULL, 488142592188416, '123456', b'0', 1, '张学友', NULL, NULL, '2022-08-02 10:14:44', NULL, 0);
INSERT INTO `sys_user` VALUES (933882217762816, 595658314510336, 'cd_test1123', '成都彭于晏', 1, '13566885522', '12345678@qq.com', '', '', NULL, 488142592188416, '123456', b'0', 1, '张学友', NULL, NULL, '2022-08-02 10:15:59', NULL, 0);
INSERT INTO `sys_user` VALUES (934333902360576, 595225483309056, 'cd_test11233', '成都彭于晏', 1, '13566885522', '12345678@qq.com', '', '', NULL, 488142592188416, '123456', b'0', 1, '张学友', NULL, NULL, '2022-08-02 10:17:47', NULL, 0);
INSERT INTO `sys_user` VALUES (949403113529344, 595704787398656, 'm-1', '成都彭于晏', 1, '13566885522', '12345678@qq.com', '', '', NULL, 720239029960704, '123456', b'0', 1, '张学友', NULL, NULL, '2022-08-02 11:17:40', NULL, 0);
INSERT INTO `sys_user` VALUES (950877340082176, 595811377246208, 'hr-1', '成都彭于晏', 1, '13566885522', '12345678@qq.com', '', '', NULL, 519334167793664, '123456', b'0', 1, '张学友', NULL, NULL, '2022-08-02 11:23:31', NULL, 0);
INSERT INTO `sys_user` VALUES (951002187735040, 595658314510336, 'cd_test111111', '成都彭于晏', 1, '13566885522', '12345678@qq.com', '', '', NULL, 720239029960704, '123456', b'0', 1, '张学友', NULL, NULL, '2022-08-02 11:24:01', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_users_jobs
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_jobs`;
CREATE TABLE `sys_users_jobs` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `job_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`job_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_users_jobs
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
